Recording Level of Effort

You can record and compare planned level of effort with the actual level effort devoted in creating and managing the mapping specifications for an ETL process.

To record the level of effort, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. Under the Workspace Mappings pane, click the required map.

    3. At the bottom of the central pane, you can locate the Additional Mapping Information pane.

  3. Expand the Additional Mapping Information pane.
  4. Use to scroll right.
  5. Click the Level of Effort tab.
  6. Click .

    7. The following page appears.

  7. Enter appropriate values in the fields. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.

    8. Field Name

    Sub-Fields

    Description

    Planned Level of Effort

    Mapping Effort

    Specifies the planned mapping effort in days.

    For example, 11.5 days.

    ETL Effort

    Specifies the planned ETL effort in days.

    For example, 10.5 days.

    Notes

    Specifies notes about the planned level of effort.

    For example: Planned level of effort took all the project requirements into account.

    Actual Level of Effort

    Mapping Effort

    Specifies the actual mapping effort in days.

    For example, 11.0 days.

    ETL Effort

    Enter the actual ETL effort in days.

    For example, 9.5 days.

    Notes

    Specifies the notes about the actual level.

    For example: Actual level of effort were lesser than the planned level of effort.
  8. Click .

    9. The Level of Effort tab is updated.